CREATE TABLE [dbo].[TOUR_HDV]
(
[MA_TOUR] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MA_HDV] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TOUR_HDV] ADD CONSTRAINT [PK_TOURHDV] PRIMARY KEY CLUSTERED  ([MA_TOUR], [MA_HDV]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_TOURHDV_MAHDV] ON [dbo].[TOUR_HDV] ([MA_HDV]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TOUR_HDV] ADD CONSTRAINT [FK_TOURHDV_HDV] FOREIGN KEY ([MA_HDV]) REFERENCES [dbo].[HUONG_DAN_VIEN] ([MA_HDV])
GO
ALTER TABLE [dbo].[TOUR_HDV] ADD CONSTRAINT [FK_TOURHDV_TOUR_CBVC] FOREIGN KEY ([MA_TOUR]) REFERENCES [dbo].[TOUR] ([MA_TOUR])
GO
